IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'RecommendationDeleteByID')
	BEGIN
		DROP  Procedure  RecommendationDeleteByID
	END

GO

CREATE Procedure RecommendationDeleteByID
(
	@RecommendationID int
)
AS

DELETE Recommendations
WHERE RecommendationID = @RecommendationID